USE [demo]
GO
/****** Object:  Table [dbo].[MESSAGE_QUEUE]    Script Date: 06/12/2011 21:15:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_QUEUE](
	[MESSAGE_ID] [int] IDENTITY(1,1) NOT NULL,
	[MESSAGE_GUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_MESSAGE_QUEUE_MESSAGE_GUID]  DEFAULT (newid()),
	[CREATED_TIME] [datetime] NOT NULL CONSTRAINT [DF_MESSAGE_QUEUE_CREATED_TIME]  DEFAULT (getdate()),
	[MODIFIED_TIME] [datetime] NOT NULL CONSTRAINT [DF_MESSAGE_QUEUE_MODIFIED_TIME]  DEFAULT (getdate()),
	[STATUS] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[SENDER] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[SUBJECT] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[SUMMARY] [nvarchar](max) COLLATE Danish_Norwegian_CI_AS NULL,
	[MESSAGE] [xml] NOT NULL
) ON [PRIMARY]
